Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
himani_a_agrawa
New Contributor II

Re: Build Logic to repetitive devices as 1, using loops/sum/count/if/set analysis

Can you please explain me your logic, I am unable t collect facts. 

Also, How can we use expression, to exactly count no of devices down for 3/7 days. 

vvira1316
Valued Contributor II

Re: Build Logic to repetitive devices as 1, using loops/sum/count/if/set analysis

Hi,

There was an error in calculation that I've corrected. I've included new QVW file as well as an Excel file that will help you understand the data scenario.  You can compare information between Excel and QVW.

I hope explanation in word document will aid in understanding.

Data Model can be cleaned up and some additional/meaningful flag can be created for calculations.

KPIs and Expressions will have to be worked out using Set Analysis.

Let me know if you will need any further help.

BR,

Vijay

himani_a_agrawa
New Contributor II

Re: Build Logic to repetitive devices as 1, using loops/sum/count/if/set analysis

Can we simplify the data model, since I already have other data table, which is making it more complex.

Attached is the snip of showing my data tables.  

 

vvira1316
Valued Contributor II

Re: Build Logic to repetitive devices as 1, using loops/sum/count/if/set analysis

Here is the simplified file