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: 
tripatiqv
Partner - Contributor III
Partner - Contributor III

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
trdandamudi
Master II
Master II

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
trdandamudi
Master II
Master II

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

tripatiqv
Partner - Contributor III
Partner - Contributor III
Author

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.

 

olivetwist
Creator
Creator

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

 

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

olivetwist
Creator
Creator

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

trdandamudi
Master II
Master II

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.

 

tripatiqv
Partner - Contributor III
Partner - Contributor III
Author

For Selecting single value your solution working fine.

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

Please check.

trdandamudi
Master II
Master II

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

 

MultipleSelection.PNG