topic Re: Conditional in QlikView

Conditional

Thu, 22 Aug 2013 12:36:39 GMT

Hi,

I need some help with conditional. Let say i have a table that i got from script that looks like this

Number Value

5250 100,00

5450 150,00

6550 200,00

6670 200,00

If i create a CHART that uses number and value how to limit that chart to only show values that contain certain number or group of numbers. Example, how to only show 5250 (nothing else), or how to show all that start on 5%.

Thanks in advance.

Re: Conditional

Gysbert_Wassenaar — Thu, 22 Aug 2013 12:39:58 GMT

If you want to show only the values of number 5250 the easiest way is to add a listbox for the Number field and then select 5250 in that listbox. If you want the hardcode that value in the table you can try using Number as dimension and as expression sum({<Number={5250}>}Value).

Re: Conditional

cesaraccardi — Thu, 22 Aug 2013 12:42:12 GMT

Hi,

That's quite simple, for example if you create a chart using "Number" as a dimension and an expression like: sum({$<Number={5250}>} Value)

If you want to show all that start with 5:

sum({$<Number={'5*'}>} Value)

Regards,

Cesar