Discussion Board for collaboration related to Creating Analytics for QlikView.
Is it possible to create a listbox based on measures(expressions) in a graph
I have sum(sales) and sum(budget) in a graph.
Can i then make a listbox, where i can select Sum(sales) and sum(budget)
So when i select these, only the one i select will be shown in my graph....
Go to Solution.
Create a inline table with two fields for example.
Load * inline [
Use this field as filter.
Then in chart expression use the "Conditional" option, where you can write the logic to show the Sum(Sales) when Sales is selected in Expression field and so on.
Hope the logic is clear.
I Follow you.
But what would you write in your conditional?
How do you in your conditional refer to Sales under Expression??
something like this:
WildMatch(Concat(Expression, ' / '), 'Sales') ?
Say for example.
Your conditional Expresison will be (for Sales expression)
and for Budget it will be
If i use wildmatch do i have to write the whole name? or is there something like in SQL where you can use % so i dont have to write the whole name..
Lets say if i write 'Sal' instead of Sales do i then need some kind of prefix?
Yes wildmatch is same like 'LIKE' in sql.
With wildmatch function you can use the '*' same like '%' in like function.
You need to write 'Sal*' for sales.
btw. one last questions. If i do this, i can only select one at the time. What if i want to select two? then it says All expressions disabled!
Try *Sal* in wildmatch.