Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am new to qlikview.
I have below issues.
below is the desciption.
I have three parameters and one chart.
I want to apply only one parameter to the chart ,
when user selects parameters.
Remaining two parameters selections should not affect to chart.
I have use below expression in chart.
=
count( {1<[Month end]= P([Month end])>} [Product])
Below is the Example for Month end parameters.
Month end
Jan-2014
Feb-2014
Mar-2014
Apr-2014
Above Expression is working as expected ,
when i select Feb-2014,
Mar-2014 and apr-2014 and other two parameters selection is not impacting on the
chart as expected.
But, somehow,
when we select Jan-2014,
Chart does not show any data,
ven though, we have data for Jan-14.
does it because there is not any month prior to Jan-2014 ?
what would be work around ?
what modification should i change in above expression ?
=
count( {1<[Month end]= P([Month end])>} [Product])
any help would be appreciated.
Thanks!.
So you are making possible selection and getting count of product. Is there specific reason you are using set analysis here? Can you just use Count (Product)?
Hi Satyadev,
there is no any specific reason to use set analysis.
I have three parameters,
i want to only apply Month end Parameters in the chart.
Other two Parameters selection should not affect on the chart.
when user select Month end ,
then only chart should show results for that month,
irrespective of the other two parameters.
is there any other way apart from set analysis ?
Thanks for your help.
I am not sure if I understood correctly, you may try below script. The script is excluding parameter1 and parameter2 from selection.
=Count({$<Parameter1=, Parameter2=>} Product)
=
count( {1<[Month end]= P([Month end]), Dimesion2 = , Dimension3 = >} [Product])
If the above is not working, load your sample file along with possible output you required.
Thanks Manish, it works!.
Kindly close the thread by selecting correct/helpful answer...