Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikians,
I am stuck to apply 1 filter direct in the data, please help me with that.
So I need only Body Lotion data in the data set (Sheet).
Body lotion is in Sub Category, Please help me with the formulas also sharing the Snip for better understanding.
Thanks
KC
Using a calculated dimension as below while suppressing null values.
Aggr(Only({$<[Sub Category]={'Body Lotion'}>} [Sub Category]), [Sub Category],[Partner Name],SKU)