we have a requirement where the user wants previous 'N' no of ProductID when he selects a particular productID. He will provide the value of N using variable extension.
This we were able to achieve if the dimension is only Product ID but if we use calculated dimension as Pick(Dim, ProductID, 'Variance') then we get previous ProductID values as null as shown below
we tried adding Previous ProductID is set analysis
Also we tried ignoring the PRoductID filter
but we were getting null values
Is there any workaround to achieve this
I have attached sample app for reference
I don't have QS installed. Can you try this way?
There will be an input box where the user will set the no of Previous IDs to be displayed,
For example if the user sets the value as 12 and he selects ProductID as 15 then in the data grid values from 3 to 15 should be displayed along with measures
If you observe in the screenshot, if we select productid as 3 then all previous ProductID measure values are showing null
Can you help resolve this issue
Hi Sunny ,
We are using Pick(Dim, ProductID, 'Variance') as Dimension because we want measures in columns along with the Dimension.In Qliksense we cannot keep measures in rows and columns at the same time so to overcome this limitation we are using Pick(Dim.ProductID,'Variance' ) .