topic Re: expr correct me ? in QlikView

expr correct me ?

Anonymous — Fri, 09 Jan 2015 10:38:09 GMT

=if(GetSelectedCount(product)>1,'select only one value',if($(vSum)=0,'no data for this ' or if($(vavg)=0,'no data for this 'or if($(vexp)=0,'no data for this '))))

here if product count is greater than one then need to show 'select only one value'

if product count is equal or <1 then it has check any above variables having value '0'

if it have then display 'no data to display'

here vsum is sum(sales) , vavg=avg(sales) vexpo is expensive of sales.

pls give this if condition

Re: expr correct me ?

morganaaron — Fri, 09 Jan 2015 10:42:18 GMT

=if(GetSelectedCount(product)>1,

'select only one value',

if($(vSum)=0 or $(vavg)=0 or $(vexp)=0,

'no data for this ',

)

Thought worth mentioning, if one of your variables isn't zero, you currently aren't showing anything..!

Re: expr correct me ?

Anonymous — Fri, 09 Jan 2015 10:53:07 GMT

Thanks for ur reply

if selected count 1 means i have to see the chart

in that selection field if no data means then i have too see 'nodata for this '

my variables wont be 0 always but it has to check evry selection and if its not zero then i have too see data on chart

if its 0 then i have see mess no data to display

Re: expr correct me ?

morganaaron — Fri, 09 Jan 2015 11:01:23 GMT

If you want to hide the chart where more than one product is selected, stick it in the layout tab as a conditional show and put the GetSelectedCount <> 1 part in there - you'll also then want a textbox that appears if the inverse is true (so if GetSelected > 1) that tells the user to select only one.

You'll then want the other part in your expression, assuming it's a straight table that will allow text to be shown, you'd want your expression to be something like:

if($(vSum)=0 or $(vavg)=0 or $(vexp)=0, 'no data for this ', sum(...))

So that it'll show 'No Data' if any of those = 0, but if it has values for them, show whatever you're wanting to show.

Otherwise, put it all in a conditional show on the layout tab, and have either one or multiple textboxes appear if any conditions are true.