Varoothini | Reputations

Posted an answer
ValQ to casual users

Hi, It depends on which ValQ edition you are using: ValQ Collaborate - No, all the users need to be part of the same ValQ workspace. ValQ Certified - Yes, the model creator would need the license...

March 23, 2021 5
Received an upvote
February 16, 2021 2
Posted an answer
Balance sheet

Hi, This is currently not possible in ValQ. We are working on implementing that.

February 16, 2021 5
Posted an answer
Formula using constant to recalculate data in model in sim

Hi, We tried to recreate your query using the following steps. Data node with row values for 12 periods, 2 constant nodes - A and B with values as 100 and 1000 respectively and a formula node Formula...

January 12, 2021 5
Received an upvote
November 18, 2020 2
Posted an answer
export excel

Hi, Publish the report to Power BI Service to download/export.

November 18, 2020 5
Posted an answer
Power BI Free or Pro ?

Hi, You would need Power BI free and a Power BI account to get ValQ from PBI AppSource

November 18, 2020 5
Posted an answer
Combine advanced Model with Data supply

Hi, Combining advanced model with data supply is possible, could you provide more details so I can better understand your question. For the Category section, you can take the key column from the dimension...

November 17, 2020 5
Posted an answer
Where can i define Dimensional Node’s

Hi, Thank you. Dimensional node is not available for Power BI version, it's available only on lumira and would come to SAAS.

November 16, 2020 5
Posted an answer
99% more depreciation from 0 are 0

Hi, The default method of simulation is Pct Change to baseline. You can change the simulation method by clicking the icon highlighted in the below image and choose Manual to edit the values for simulation...

November 12, 2020 5
Commented on a post

Hello Peter, In case you aren't able to remodel the data, DAX measures can be of help to overcome this issue. With DAX you can create a measure for each year as data series using CALCULATE.

October 28, 2020 2
Received an upvote
October 27, 2020 2
Received an upvote
October 27, 2020 2
Posted an answer
Multi year data – selects oldest data – how to change to default to most recent data?

Hello Peter, ValQ takes the first field under Value as the baseline data series(default). In the images, you can see 2020 is the first field and it's taken as baseline. The series dropdown can be used...

October 27, 2020 5
Posted an answer
Error when there are blank periods of data, expect to see data in the correct month.

Hello Peter, Steps to get the correct result: Pivot the year column along with the value column that you have in the Query Editor to get 3 data series (2018,2019,2020). 2. Add these data series...

October 27, 2020 5
Registered
Can we Change how the way Charts calculate Variance

Currently, I have 2 values, Actual and AOP(Goal), by default the Variance calculated by charts are showing Act-AOP. But we want to show AOP-ACT as the Variance is it possible?

October 27, 2020 2