topic Re: Set Analysis - issue in P() function in QlikView

Set Analysis - issue in P() function

Tue, 05 Aug 2014 01:31:17 GMT

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!.

Re: Set Analysis - issue in P() function

Anonymous — Tue, 05 Aug 2014 01:53:12 GMT

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)?

Re: Set Analysis - issue in P() function

Tue, 05 Aug 2014 02:05:02 GMT

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.

Re: Set Analysis - issue in P() function

Anonymous — Tue, 05 Aug 2014 02:20:00 GMT

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)

Re: Set Analysis - issue in P() function

MK_QSL — Tue, 05 Aug 2014 08:05:03 GMT

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.

Re: Set Analysis - issue in P() function

Tue, 05 Aug 2014 15:16:49 GMT

Thanks Manish, it works!.

Re: Set Analysis - issue in P() function

MK_QSL — Tue, 05 Aug 2014 15:28:26 GMT

Kindly close the thread by selecting correct/helpful answer...