Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Show limited data for a particular value of dimension in qlikview

Hi all,

 

I have attached the .qvw file and excel source file.

My requirement is 

For material group PEN I need to give user a selection of SKU, whatever user select the value of SKU of PEN
that much of data should be visible in chart.

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Re: Show limited data for a particular value of dimension in qlikview

Got it. Here is one more way to do in Set Anlaysis and the expression is:

If (getfieldselections(SKU) > 0,
     Sum({1<[Material group]-={'PEN'}> + <SKU ={'$(=getfieldselections(SKU))'}>} Sales),
             Sum(Sales))

See the attached file for the chart. Hope this helps.

 

View solution in original post

7 Replies
Highlighted
Master II
Master II

Re: Show limited data for a particular value of dimension in qlikview

Please see the attached qvw file where I created a list box based on your requirement. Hope this helps.

Highlighted
Partner
Partner

Re: Show limited data for a particular value of dimension in qlikview

Hi

Thanks for your reply,

When I select any sku value material group pen the other data  of other material group of the chart should not disturb.

for example if I select BALL PEN of material group PEN then as per the attached excel the chart value should come.

 

Highlighted
Creator
Creator

Re: Show limited data for a particular value of dimension in qlikview

Right click the object you want to remain unchanged and select "Detach"

 

Edit: sorry, misread the example attached.  I will take another look

Highlighted
Creator
Creator

Re: Show limited data for a particular value of dimension in qlikview

Try this as your expression in the "Sales" object:

IF(MATCH([Material group],GetFieldSelections([Material group])),
SUM({<[Material group]=>}Sales),
SUM({<[Material group]=,SKU=>}Sales))

Highlighted
Master II
Master II

Re: Show limited data for a particular value of dimension in qlikview

Got it. Here is one more way to do in Set Anlaysis and the expression is:

If (getfieldselections(SKU) > 0,
     Sum({1<[Material group]-={'PEN'}> + <SKU ={'$(=getfieldselections(SKU))'}>} Sales),
             Sum(Sales))

See the attached file for the chart. Hope this helps.

 

View solution in original post

Highlighted
Partner
Partner

Re: Show limited data for a particular value of dimension in qlikview

For Selecting single value your solution working fine.

If I select more than one value then it is not working.

Please check.

Highlighted
Master II
Master II

Re: Show limited data for a particular value of dimension in qlikview

I am able to select it. Please see the screen shot below:

 

MultipleSelection.PNG