Discussion Board for collaboration regarding Qlik DataMarket.
This is my data in excel file.
i created a straight table like below
i want to change my 2 columns in the table dynamically to BudgetSales and Budget Revenue by using a list box in UI,like
i had done dis script in Edit script
LOAD * INLINE [
but while changing expresions in chart
im not getting the result
some thing is wrong in my expression like
=if(GetCurrentSelections ('Budget'), Sum ([ActSales]),Sum ([BudgetSales]))
pls give me the ideas
Go to Solution.
Set a variable in your script as follows:
Then use the following as a show conditional in your expression:
Let me know if you have any other questions.
Try using variables instead. I'll try to create an example, but the concept is similar:
You would have two expressions (one for ActualSales and one for BudgetSales). You would use the conditional property to determine if the expression should get calculated:
This would be based on your variable - which is determined by the list box you have above (using the GetFieldSelections function you described).
Please see attached for more details.
Im not able to open that qvw file..
Will u pls provide me the screenshots or
Expressions of wat u did in dat qvw file..
It will be more helpful to me..