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

Show limited data for a particular value of dimension in qlikview

tripatiqv — Sat, 16 Nov 2024 03:02:08 GMT

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.

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

trdandamudi — Thu, 11 Jul 2019 12:46:46 GMT

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

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

tripatiqv — Thu, 11 Jul 2019 13:04:37 GMT

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.

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

olivetwist — Thu, 11 Jul 2019 13:12:44 GMT

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

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

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

olivetwist — Thu, 11 Jul 2019 13:24:20 GMT

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

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

trdandamudi — Thu, 11 Jul 2019 17:02:40 GMT

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.

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

tripatiqv — Fri, 12 Jul 2019 09:53:31 GMT

For Selecting single value your solution working fine.

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

Please check.

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

trdandamudi — Fri, 12 Jul 2019 11:32:23 GMT

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