Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - issue in P() function

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

6 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

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.

Anonymous
Not applicable
Author

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)

MK_QSL
MVP
MVP

=

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.

Not applicable
Author

Thanks Manish, it works!.

MK_QSL
MVP
MVP

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